Tabela MandayCostData

Definicja tabeli MandayCostData

Name

MandayCostData

Code

MandayCostData

Comment

Tabela przechowujaca dane o ilosci i kosztach osobodni stworzona, aby dalo sie wybierac ilosci i koszty osobodni równiez w widokach, w których nie da sie wywolac procedury skladowanej GetEpisodeDaysCosts. Ta tabela jest napelniana na podstawie wlasnie tej procedury


Lista kolumn tabeli MandayCostData

Name

Code

MandayCostDataID

MandayCostDataID

EpisodeID

EpisodeID

EpisodeTypeID

EpisodeTypeID

EpisodeStatID

EpisodeStatID

EventID

EventID

PeriodID

PeriodID

CostAccountID

CostAccountID

ServID

ServID

UnitsCount

UnitsCount

Price

Price

EventDays

EventDays

LastModifiedDT

LastModifiedDT

Deleted

Deleted

Recalculate

Recalculate


Kolumna MandayCostDataID tabeli MandayCostData

Definicja kolumny MandayCostDataID tabeli MandayCostData

Name

MandayCostDataID

Code

MandayCostDataID

Data Type

NUMBER(9)

Mandatory

Yes

Comment

 


Kolumna EpisodeID tabeli MandayCostData

Definicja kolumny EpisodeID tabeli MandayCostData

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EpisodeTypeID tabeli MandayCostData

Definicja kolumny EpisodeTypeID tabeli MandayCostData

Name

EpisodeTypeID

Code

EpisodeTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeStatID tabeli MandayCostData

Definicja kolumny EpisodeStatID tabeli MandayCostData

Name

EpisodeStatID

Code

EpisodeStatID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli MandayCostData

Definicja kolumny EventID tabeli MandayCostData

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PeriodID tabeli MandayCostData

Definicja kolumny PeriodID tabeli MandayCostData

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountID tabeli MandayCostData

Definicja kolumny CostAccountID tabeli MandayCostData

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServID tabeli MandayCostData

Definicja kolumny ServID tabeli MandayCostData

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli MandayCostData

Definicja kolumny UnitsCount tabeli MandayCostData

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Price tabeli MandayCostData

Definicja kolumny Price tabeli MandayCostData

Name

Price

Code

Price

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Kolumna EventDays tabeli MandayCostData

Definicja kolumny EventDays tabeli MandayCostData

Name

EventDays

Code

EventDays

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli MandayCostData

Definicja kolumny LastModifiedDT tabeli MandayCostData

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna Deleted tabeli MandayCostData

Definicja kolumny Deleted tabeli MandayCostData

Name

Deleted

Code

Deleted

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga usuniecia


Kolumna Recalculate tabeli MandayCostData

Definicja kolumny Recalculate tabeli MandayCostData

Name

Recalculate

Code

Recalculate

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Lista kluczy tabeli MandayCostData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MandayCostData

Definicja klucza Identifier_1 tabeli MandayCostData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment